MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Role = 66

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Artist Nationality

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
14891 58.658 0 1 16151 American Decorative Arts 1 Drawing 23 Design for Autumn Landscape window American 1         Designer|Artist|Maker 66 Design attributed to Agnes F. Northrop|Louis Comfort Tiffany|Tiffany Studios American, Flushing, New York 1857–1953 New York, New York|American, New York 1848–1933 New York|1902–32   Northrop, Agnes F.|Tiffany, Louis Comfort|Tiffany Studios  2344 American 1 1857 |1848 |1902 1953 |1933 |1932 1923 1923 1923 Watercolor, ink, and gouache on paper 2531 18 1/4 x 13 1/2 in. (46.4 x 34.3 cm) Gift of Robert W. de Forest, 1925, transferred from Archives, 1958 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
89615 2009.421 0 0 154395 Costume Institute 8 Evening jacket 5930 Evening jacket French 7         Designer|Artist|Maker 66   Elsa Schiaparelli|Jean Cocteau|House of Lesage Italian, 1890–1973|French, Maisons-Laffitte 1889–1963 Milly-la-Forêt|French, founded 1924   Schiaparelli Elsa|Cocteau, Jean|Lesage House of 6860 Italian|French|French 180 1890 |1889 |1924 1973 |1963 |9999 fall 1937 1937 1937 linen, metal 15494   Purchase, Friends of The Costume Institute Gifts, 2009                         © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
101716 07.102.6 0 0 189234 European Sculpture and Decorative Arts 3 Plateau or salver 7142 Plateau or salver British, Birmingham, after German original 2181         Designer|Artist|Maker 66 After a design by|After an original by Nicholas Briot|Kasper Enderlein|Elkington & Co. French, 1579–1646, active England after 1633|1560–1633|British, Birmingham, 1829–1963   Briot Nicholas|Enderlein, Kasper|Elkington & Co. 8462 British 7 1579 |1560 |1829 1646 |1633 |1963 19th century, after 1611 original 1800 1899 Pewter 104 Diameter: 18 in. (45.7 cm) Rogers Fund, 1907                       Metalwork-Electrotype 136   Metropolitan Museum of Art, New York, NY 1
107024 22.177.1 0 1 194940 European Sculpture and Decorative Arts 3 Door 56 Door (part of a set) British, London 222         Designer|Artist|Maker 66 From a cabinet based on a design by|Probably painted by|for the firm of Thomas Edward Colcutt|Charles Fairfax Murray|Collinson and Lock 1840–1924|British, London 1849–1919 London|London, active 1890–97   Colcutt Thomas Edward|Murray, Charles Fairfax|Collinson and Lock 9442 British 7 1840 |1849 1924 |1919 ca. 1871 1866 1876 Painted and ebonized mahogany, copper mounts 21702 Overall: 24 3/8 × 15 3/16 in. (61.9 × 38.6 cm) Gift of Mrs. Frederick H. Allen, 1922                       Paintings-Decorative 309   Metropolitan Museum of Art, New York, NY 1
139738 2009.280 1 1 236691 European Sculpture and Decorative Arts 3 Tapestry 1084 Hunters in a Landscape British, probably London 251         Designer|Artist|Maker 66 Partly based on a woodcut by|Woven by Anonymous|Jost Amman|Anonymous Flemish weavers Swiss, Zurich before 1539–1591 Nuremberg designer Anonymous|Amman, Jost|Anonymous Flemish weavers 12759 Swiss 61 1539 1591 ca. 1575–95 1570 1600 Wool, silk (14 warps per inch; 5-6 per cm) 25414 H. 70 7/8 x W. 181 7/8 in. (180 x 462 cm); Weight (rolled on tube): 38lb. (17.2367kg) Purchase, Walter and Leonore Annenberg Acquisitions Endowment Fund, Rosetta Larsen Trust Gift, and Friends of European Sculpture and Decorative Arts Gifts, 2009                       Textiles-Tapestries 186   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 375.308ms · Data license: CC0 · Data source: metmuseum/openaccess